package com.cq.androidtools.room1

import androidx.room.Dao
import androidx.room.Insert
import androidx.room.OnConflictStrategy
import androidx.room.Query

/**
 * 作者: CQ
 * 日期: 2021-05-13
 * 说明:
 */
@Dao
interface MakeDao {
    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insertMake(makeBean: MakeBean)


    @Query("select max(id) as id,sId,type,sum(cj) as cj from Make group by sId,type")
    fun selectMake() : List<MakeBean>
}